<?php
	include "common.php";
	session_start();
	error_reporting(0);
	if($_SESSION['logInCheck']!=1){
		header('Location: index.php?loginInfo=false');
	}
	$userLink = $_SESSION['userLink'];
	if($userLink!="hrpage.php"){
		echo "Sorry, You have no right to visit this page!!";
		exit;
	}
	$eid = $_SESSION['id'];
	$userFname = $_SESSION['userFname'];
	$userLname = $_SESSION['userLname'];
	$role = $_SESSION['role'];	
	$userSql = "SELECT * FROM user WHERE e_id = '$eid'";
	$userSqlQuery = mysql_query($userSql);
	$userSqlResult = mysql_fetch_assoc($userSqlQuery);
	
	$email = $userSqlResult['email'];
	$timezone_offset = 6; // for getting local time offset hrs
	$systemDate = gmdate('y-m-d', time()+$timezone_offset*60*60);
	$compToday = strtotime($systemDate);
	
	$attendanceSql = "SELECT * FROM apply_leave WHERE approval = 'ACCEPTED' AND '$systemDate' between leave_from AND leave_to";
	$attendanceSqlQuery = mysql_query($attendanceSql);
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<link rel="stylesheet" href="index.css" type="text/css" />
<link rel="stylesheet" type="text/css" href="hr_attendance.css" />
<link rel="icon" type="image/ico" href="images/favicon.ico"></link> 
<link rel="shortcut icon" href="images/favicon.ico"></link>
<script src="curvycorners.src.js" type="text/javascript"></script>
<script src="login.js" type="text/javascript"></script>
<title><?php echo "Welcome to ".$userFname." ".$userLname; ?></title>
</head>

<body>
<div class="main_div_other">
	<p><img src="images/creato_logo.jpg" /></p>
    <p id="creatobd">www.creatobd.com</p>
    <p id="date"><script>document.write(new_month+" "+new_date+", "+old_date.getFullYear()+" || "+new_day);</script></p>
    <div class="other_page_icons">
    	<div class="new_notification">
        	<img src="images/arrow_up.JPG" /><p>You have a new notification</p>
        </div><!--end of new_notification-->
    	<ul>
        	<a href="hrpage.php"><li><div id="home"></div><p>home</p><p class="present_class"><img src="images/arrow_up.JPG" /></p></li></a>
            <a href="hr_employee.php"><li><div id="employee"></div><p>employee</p><p class="present_class"><img src="images/arrow_up.JPG" /></p></li></a>
            <a href="hr_onduty.php"><li><div id="onduty"></div><p>on duty</p><p class="present_class"><img src="images/arrow_up.JPG" /></p></li></a>
            <a href="hr_attendance.php"><li><div id="attendance"></div><p>attendance</p><p class="present_class"><img src="images/arrow_up.JPG" /></p></li></a>
            <a href="hr_leave.php"><li><div id="leave"></div><p>leave</p><p class="present_class"><img src="images/arrow_up.JPG" /></p></li></a>
            <a href="hr_notification.php"><li><div id="notification"></div><p>notification</p><p class="present_class"><img src="images/arrow_up.JPG" /></p></li></a>
            <a href="hr_black_box_message.php"><li><div id="blackbox"></div><p>black box</p><p class="present_class"><img src="images/arrow_up.JPG" /></p></li></a>
            <a href="#"><li><div id="hrpolicy"></div><p>hr policy</p><p class="present_class"><img src="images/arrow_up.JPG" /></p></li></a>
            <a href="index.php"><li><div id="logout"></div><p>log out</p><p class="present_class"><img src="images/arrow_up.JPG" /></p></li></a>
        </ul>
    </div><!-- end of other_page_icons-->
    
</div><!-- end of main_div_other-->
<div class="othrpage_1">
    <p>view as: <a href="hr_leave.php?check=1">in leave</a> | <a href="hr_leave.php?check=2">govt. holiday</a> | <a href="hr_leave.php?check=3">apply</a></p>
</div><!-- end of othrpage_1-->
<div class="human_portal">
  		<p>creato human resourse portal</p>
</div><!-- end of human_portal-->
<?php
	$checkSubmit = $_GET['check'];
	
?>
<?php
	if ($checkSubmit == 1)
	{
		?>
		<div class="page_content1">
  		<table  border="0" cellpadding="0" cellspacing="0" class="header_page_content" width="800">
        	<tr class="table_header_1"  valign="top">
            	<td align="center" colspan="8">Employees in Leave Today</td>
            </tr>
			<tr valign="top" class="table_header_2">
				<td width="100px"><p>Employee Id</p></td>
				<td width="100px"><p>First Name</p></td>
				<td width="100px"><p>Last Name</p></td>
				<td width="100px"><p>Leave From</p></td>
                <td width="100px"><p>Leave Duration</p></td>
			</tr>
    </table>
		
	<?php
	while ($data = mysql_fetch_assoc($attendanceSqlQuery))
	{
		$id =$data['e_id'] ;
	?>
		<table class="header_page_content" border="0" cellpadding="0" cellspacing="0" width="800">
			<tr valign="top" class="table_header_3">
				<?php 
					$userSql = "SELECT * FROM user WHERE e_id = '$id'";
					$userSqlQuery = mysql_query($userSql);
					$userData = mysql_fetch_assoc($userSqlQuery);				
					
					$leaveSql = "SELECT * FROM apply_leave WHERE approval = 'ACCEPTED' AND '$systemDate' between leave_from AND leave_to";
					$leaveSqlQuery = mysql_query($leaveSql);
					$leaveSqlQueryResult = mysql_fetch_assoc($leaveSqlQuery);
				?>
				<td width="100px"><p><?php echo $id;?></p></td>
				<td width="100px"><p><?php echo $userData['f_name'];?></p></td>
				<td width="100px"><p><?php echo $userData['l_name'];?></p></td>
				<td width="100px"><p><?php echo $leaveSqlQueryResult['leave_from'];?></p></td>
				<td width="100px"><p><?php echo $leaveSqlQueryResult['leave_to'];?></p></td>
			</tr>
		</table>
		<?php
	}
	?>
    </div>
	<?php } ?>
	
	<?php	
	if ($checkSubmit == 2)
	{
		$govtLeaveSql = "SELECT * FROM govt_holiday";
		$govtLeaveSqlQuery = mysql_query($govtLeaveSql);
		?>
		<div class="page_content1">
  		<table  border="0" cellpadding="0" cellspacing="0" class="header_page_content" width="800">
        	<tr class="table_header_1"  valign="top">
            	<td align="center" colspan="8">List of Government Leave</td>
            </tr>
			<tr valign="top" class="table_header_2">
				<td width="100px"><p> Government Leave Title  </p></td>
				<td width="100px"><p> Leave Date  </p></td>
				<td width="100px"><p> Number of Days  </p></td>
				<td width="100px"><p> Dependancy on Moon</p></td>
			</tr>
    </table>
		
	<?php
	while ($data = mysql_fetch_assoc($govtLeaveSqlQuery))
	{
	?>
		<table class="header_page_content" border="0" cellpadding="0" cellspacing="0" width="800">
			<tr valign="top" class="table_header_3">
				<td width="100px"><p><?php echo $data['heading'];?></p></td>
				<td width="100px"><p><?php echo $data['date'];?></p></td>
				<td width="100px"><p><?php echo $data['n_days'];?></p></td>
				<td width="100px"><p><?php if($data['dependancy'] == 1) echo "Yes"; else echo "No";?></p></td>
			</tr>
		</table>
		<?php
	}
	?>
    </div>
	<?php }
	if ($checkSubmit == 3)
	{
		?>
		<form method="post" action="hr_get_leave.php">
			<table cellpadding="0" cellspacing="0" class="apply4leave_table">
				<tr valign="top">
					<td>Employee Id</td>
					<td><input type="text" value="<?php echo $_SESSION['id']?>"  name="id" readonly=""/></td>
				</tr>
				<tr valign="top">
					<td>Employee Name</td>
					<td><input type="text" value="<?php echo $_SESSION['userFname']?>"  name="name" readonly=""/></td>
				</tr>				
				<tr valign="top">
					<td>Leave Type</td>
					<td>
						<select name="leaveType">
							<option value="Casual">Casual</option>
							<option value="Earn">Earn</option>
							<option value="Maternal">Maternal</option>
							<option value="Paternal">Paternal</option>
						</select>
					</td>
				</tr>
				<tr valign="top">
					<td>Leave From</td>
					<td>
					<select name="day"/>
						<option value="Day">Day</option>
						<option value="1">1</option>
						<option value="2">2</option>
						<option value="3">3</option>
						<option value="4">4</option>
						<option value="5">5</option>
						<option value="6">6</option>
						<option value="7">7</option>
						<option value="8">8</option>
						<option value="9">9</option>
						<option value="10">10</option>
						<option value="11">11</option>
						<option value="12">12</option>
						<option value="13">13</option>
						<option value="14">14</option>
						<option value="15">15</option>
						<option value="16">16</option>
						<option value="17">17</option>
						<option value="18">18</option>
						<option value="19">19</option>
						<option value="20">20</option>
						<option value="21">21</option>
						<option value="22">22</option>
						<option value="23">23</option>
						<option value="24">24</option>
						<option value="25">25</option>
						<option value="26">26</option>
						<option value="27">27</option>
						<option value="28">28</option>
						<option value="29">29</option>
						<option value="30">30</option>
						<option value="31">31</option>
					</select>
					<select name="month"> 
						<option value="month">Month</option>
						<option value="1">Jan</option>
						<option value="2">Feb</option>
						<option value="3">Mar</option>
						<option value="4">Apr</option>
						<option value="5">May</option>
						<option value="6">Jun</option>
						<option value="7">Jul</option>
						<option value="8">Aug</option>
						<option value="9">Sep</option>
						<option value="10">Oct</option>
						<option value="11">Nov</option>
						<option value="12">Dec</option>
					</select>
					<select name="year">
						<option value="year">Year</option>
						<option value="2012">2012</option>
						<option value="2013">2013</option>
						<option value="2014">2014</option>
						<option value="2015">2015</option>
						<option value="2016">2016</option>
						<option value="2017">2017</option>
						<option value="2018">2018</option>
						<option value="2019">2019</option>
						<option value="2020">2020</option>
					</select>
					</td>
				</tr>
				<tr valign="top">
					<td>Leave To</td>
					<td>
					<select name="day1"/>
						<option value="Day">Day</option>
						<option value="1">1</option>
						<option value="2">2</option>
						<option value="3">3</option>
						<option value="4">4</option>
						<option value="5">5</option>
						<option value="6">6</option>
						<option value="7">7</option>
						<option value="8">8</option>
						<option value="9">9</option>
						<option value="10">10</option>
						<option value="11">11</option>
						<option value="12">12</option>
						<option value="13">13</option>
						<option value="14">14</option>
						<option value="15">15</option>
						<option value="16">16</option>
						<option value="17">17</option>
						<option value="18">18</option>
						<option value="19">19</option>
						<option value="20">20</option>
						<option value="21">21</option>
						<option value="22">22</option>
						<option value="23">23</option>
						<option value="24">24</option>
						<option value="25">25</option>
						<option value="26">26</option>
						<option value="27">27</option>
						<option value="28">28</option>
						<option value="29">29</option>
						<option value="30">30</option>
						<option value="31">31</option>
					</select>
					<select name="month1"> 
						<option value="month">Month</option>
						<option value="1">Jan</option>
						<option value="2">Feb</option>
						<option value="3">Mar</option>
						<option value="4">Apr</option>
						<option value="5">May</option>
						<option value="6">Jun</option>
						<option value="7">Jul</option>
						<option value="8">Aug</option>
						<option value="9">Sep</option>
						<option value="10">Oct</option>
						<option value="11">Nov</option>
						<option value="12">Dec</option>
					</select>
					<select name="year1">
						<option value="year">Year</option>
						<option value="2012">2012</option>
						<option value="2013">2013</option>
						<option value="2014">2014</option>
						<option value="2015">2015</option>
						<option value="2016">2016</option>
						<option value="2017">2017</option>
						<option value="2018">2018</option>
						<option value="2019">2019</option>
						<option value="2020">2020</option>
					</select>
					</td>
				</tr>
				<tr valign="top">
					<td>Leave Reason</td>
					<td><input type="text" name="leave_reason"/></td>
				</tr>
				<tr><td><input type="submit" value="Submit" /></td></tr>
			</table>
		</form>
    </div><!-- end of page_content -->
	<?php } ?>

</body>
</html>
